Developer CD Series 1990: Discy Business/Discy Business.2mg/DEV.CD/GUIDED.TOURS/IIC.PLUS.TOUR/AT.WORK/CALC.SCRIPT

Text File | 1988-04-10 | 6.6 KB | 290 lines | [04] ASCII Text (0x0000)

File: Wreckers.Budget       REVIEW/ADD/CHANGE                Escape: Main Menu
=======A======B======C======D======E======F======G======H======I=======J=======
  1|
  2|                        BUDGET:  BIG BOY AUTO WRECKERS
  3|
  4| INCOME
  5|              Raffle, Net                                         800.00
  6|              From Big Boy for uniforms     15.00     20          300.00
  7| ---------------------------------------------------------------------------
  8| TOTAL INCOME                                                    1100.00
  9|
 10| EXPENSES
 11|              Root Beer and Pizza                                 235.00
 12|              Bats                           8.00     20          160.00
 13|              Uniforms                      50.00     20         1000.00
 14| ---------------------------------------------------------------------------
 15| TOTAL EXPENSES                                                  1395.00
 16| ===========================================================================
 17| DONATIONS NEEDED                                                 295.00
 18|
-------A------B------C------D------E------F------G------H------I-------J-------
A1:

Type entry or use OA commands                                     OA-? For Help
0 3 79 5

Spreadsheet programs let you keep track of budgets, tax returns, and
other numeric information that usually is organized in a row and
column format.
@
%

Really, the quickest way to learn about spreadsheet programs is to see
one in action.
@
~%
0 18 80 4

Here's the budget Harry Walker prepared when he was manager of the Big Boy
Auto Wreckers baseball team.
@
#%
26 10 43 7

The spreadsheet is laid out in rows
and columns.  Rows are labeled with
numbers along the left edge of the
screen; columns are labeled with
letters along the top and bottom.
@
*%
26 10 43 5

In spreadsheet jargon, the
intersection of a row and column,
like A1 or J5, is called a cell.
@
*%
26 10 43 7

For practice, try moving the cursor
to cell J6.  First, move to the
correct column.

   Press the RIGHT ARROW key 9 times.
@
#RRRRRRRRR
0 0 50 4

   Press the RIGHT ARROW key % times.
@err
26 10 43 5

Now, move to the correct row.

    Press the DOWN ARROW key 5 times.
@
#DDDDD
0 0 50 4

    Press the DOWN ARROW key % times.
@err
0 17 80 5

What makes spreadsheet programs so powerful is that they let you ask
"what if" questions to see how changing one of your projected figures
will affect all of the other information in the spreadsheet.
@
#%
0 18 80 4

In the next few minutes, we'll demonstrate what happens when we play
"what if" with some of Harry's budget figures.
@
#%
21 14 52 8

First, look at the budget.  What did Harry
estimate for income from the raffle?

 A.  $300      B.  $1100      C.  $800
@
?3C
0 17 80 5

Now, suppose Harry recalls that he was down in the dumps the day he
made up the budget and that he's quite sure the raffle will net at
least $1000.
@
#%
0 18 80 4

Your job is to change the budget so it shows the Wreckers' raffle
bringing in $1000 rather than the $800 it shows now.
@
%

Then, the spreadsheet will automatically calculate the new Total Income
and a new figure for Donations Needed.
@
%

Your first step in playing "what if" is to move the cursor to the cell
that contains the information you want to change.
@
#%
13 14 58 8

Look closely at the model.  What cell contains
Harry's estimate for the net income from the raffle?

   A. H6          B. J5          C. J6
@
?3B
22 15 43 7

The cursor is already in the correct
column so all you need to do is
move it to the correct row.

      Press the UP ARROW key once.
@
#U

     Press the UP ARROW key once.
@err
0 16 50 5

Now that the cursor is where you want
it, you can see what happens if the
Wreckers' raffle brings in $1000.
@
#%
0 11 50 8

As you type, notice that what you type
appears at the bottom of the screen.
Then watch the column numbers change
when you press RETURN.

     Type 1000 and press RETURN.
@
"1000

     Type 1000 and press RETURN.
@err
0 19 80 2
There you have it!  When you pressed RETURN, the program immediately
calculated that the amount needed from donations dropped from $295 to $95.
@
#%
0 19 80 2
You may also have noticed that the Wreckers' Total Income jumped from
$1100 to $1300.
@
#%
0 12 50 4

How did the program know to do this
recalculation?
@
#%
0 12 50 8

When Harry created the spreadsheet, he
included formulas that instructed the
program to calculate the content of
certain cells depending on the content of
other cells.

@
#%
0 12 50 8

For example, to determine the content
of cell J8, Total Income, Harry instructed
the spreadsheet program to add up the
content of cell J5 (net income from the
raffle) and cell J6 (Big Boy's contribution
to uniforms).
@
#%
0 12 50 5

When you're ready to create your own
spreadsheets, you'll learn more about how
these formulas work.
@
#%
0 14 80 5

Now, let's play "what if" again.  Only this time we'll see what happens
when expenses increase.  Specifically, we'll find out how the budget
changes when Harry learns that the cost of bats increased from $8 to $10.
@
%

First, we need to move the cursor to cell G12.  To move to column G,

     Press the LEFT ARROW key 3 times.
@
#LLL

     Press the LEFT ARROW key % times.
@err
30 17 45 5

Now, to move to row 12,

     Press the DOWN ARROW key 7 times.
@
#DDDDDDD

     Press the DOWN ARROW key % times.
@err
0 15 53 4

Change the amount to $10 and see what happens:

     Type 10 and press RETURN.
@
"10

     Type 10 and press RETURN.
@err
0 0 80 5

The total cost for bats increased from $160 to $200, total expenses
jumped from $1395 to $1435, and the donations needed increased from
$95 to $135.
@
#%
0 0 80 4
Now it's your turn to experiment. Try entering new amounts in cell J5, the
income from the raffle, and in cell G12, the price of bats. Remember, first
use the arrow keys to move the cursor to the correct cell. Then, type the
new figure and press RETURN.  Press ESC when you are ready to go on.
@
&%
0 0 80 6

The Auto Wreckers' Budget contains a relatively small amount of
information.  Most spreadsheet programs let you create spreadsheets a lot
bigger than this one.  The AppleWorks program lets you have thousands
of cells to work with.
@
#%
0 3 79 13

Now that you know what spreadsheet programs do, the question becomes
"Do you need one?"  If you'd

          -- like to budget more successfully

          -- like to keep better track of your investments, or

          -- wish it were easier to figure your income taxes

you'll probably want to add a spreadsheet program to your software
library.
@
$%
0 3 80 4

Press RETURN to find out how you can put all your pieces of software
together, or press COMMAND-ESC to return to the menu.
@
!%
@